package com.pulisher.mapper;

import com.pulisher.bean.ExamCourseScoreBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
public interface ExamCourseMapper {
    @Select("select course_name ,ROUND(sum(score) / sum(exam_user_ct),2) score from dws_exam_course_window partition (par#{date}) group by course_name")
    List<ExamCourseScoreBean> selectCourseScore(Integer date);
}
